Creating line and stacked column chart and map 16
Line and stacked column chart
a. Creating line and
stacked column chart and map
On field and shared axis Language column,
and column value WORDS PER DAY and
Line value MOM %
b. To Format, Go to General X
position = 0, y position =77, width = 533,
height = 373
c. Legend = ON color black (000000)
font family =Cambria Math, text 12 style =markers only, Match
line color =on, circle default icon =on
d. x-axis color black,
text size 15, font family = Cambria Math, minimum category width 20 Max
= 20 Inner padding 20% concatenate labels on, Title off
e. y-axis color(605E5C) text
size 15, font family Cambria
Math and title =off
f. Gridlines on color
(B3B3B3) stoke width 1, line style =solid , show
secondary= on Align zeros= On
g. Y-Axis(Line), color (FF9C80) text
Size 16 font family Cambria Math, Title= off
h. data Colors ,MOM%
= (FF9C80), Default color( 99CDE7)
i. Data labels On,
color(8952BF )text
size 21, font family Cambria Math, ,show background on , background color =white transparency 30%
j. customize series on , WORDS PER DAY color (074650) text size =21,
font family Cambria
Math, show background =on, background color = white
k. shapes area On, stroke
width 0, join types Miter Line style solid
l. Tittle on ‘MAX
LANGUAGE COMPLETENESS AVG PER DAY’ , word wrap on font
color black, background color(6DB6FF),alignment = center ,
text size = 17 font family =Cambria
Math
m. Background = off
n. Lock aspect =off
o. Border = off
p. Tooltip = on
q. Visual header= on
Follow gif.
once you are done with above detail instruction with text size and changing title so on so forth copy and past the chart 3 more time and follow gif as well as write instructions
Line and stacked column chart
On field and shared axis Monthlong
column, and column value WORDS
PER DAY and Line value MOM %
To Format, Go to
General X position = 713, y position =72, width = 567,
height = 288
Change the Title
to
Title = YEARLY COMPLETENESS PER AVG
follow Gif
Map
On field and Location = table sheet1 Language,
Latitude = Average of Latitude, Longitude = Average of longitude and
Size = Count per Day
To Format, Go to
General X position = 0, y position =374, width = 497,
height = 338
Data colors click one (fx) and Minimum = red (FF0711), and
for maximum =(118DFF ), category labels =On , color
= (666666) Text size= 17, Font family = Cambria Math, show background = off ,bubbles Size =
21, Heat map =off , Title =On change the titles to (WORDS
PER DAY BY LOCATION ) , show background=
off Too tips on , visual
header= on
And for map Legend please select insert
image from power bi ribbon go on your download zip file choose the image Once you insert the image go to power bi ribbon and select format select
Bring forward To format image general x position= 221
,Y Position= 809 ,width= 297 and height= 68
More detail screenshot and gif below please follow.
https://okviz.com/blog/design-guide-for-power-bi-slicers-and-filters